Business Intelligence with MicroStrategy Cookbook by Unknown

Author:Unknown
Language: eng
Format: epub
Publisher: Packt Publishing

Modifying the grouping in a document

Our second document has data but it's not ready for prime time yet. There are metrics but no attributes in it. So, let's go on and add some.

Getting ready

You need to have completed the previous recipe to continue.

How to do it...

We start from where we left the previous document:

Click on the Design icon in the toolbar to return to design mode.

In the Dataset Objects pane, click on the Product Subcategory attribute, drag it into the Detail section, and position it just below the Total textbox.

Click on the Interactive Mode icon to run the document.

Much better, we see the description of each subcategory and the corresponding amount; note that the Total is still showing 29M.

Click on Design and go back to design mode. This time, we add the category but instead of dragging it onto the layout we create a group. Right-click on the Category attribute and from the context menu select Add to Grouping.

The Product Category is added to the GROUPING pane above the layout and there are now two more sections: Product Category Header and Product Category Footer.

Pick the Product Category attribute and drag it onto the Product Category Header, dropping it close to the left border.

Now run the document in interactive mode and see the result. We have a paging control at the top of the document where we can select the Product Category, and most important, the Total is different. Can you tell why?

Click on the Product Category paging combobox and select Clothing, the document is updated and the Total changes, do the same for Accessories, what do you expect?

One last time select (All) from the combobox to see the entire dataset in one single view.

Save the document as it is, overwrite the existing one, and click on Run newly saved document.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.